Week 04
Feb 21
- how does Haurum et al. 2022 paper affect my thesis
FME to python
- create a notebook in acrgis pro python having a function on how to create the watershed and push the notebook to github
Feb 22
List of WRc and PACP and combine
If the image has label BSV and then add B in that image. Add the higher hierarchy label to the image
There are 4026 unique job numbers inside CCTV_Details. The job numbers can either contain the video extension such as mpg or mp4 (e.g. SANMN00692_49.MPG) as part of its name or only have the filename (e.g. 001-3648)
736 job numbers from CCTV_Details are found to follow PACP standards.
406 out of 736 job numbers have matching file names (without considering the file extension) with videos on the Gdrive.
1472 out of 3572 videos inside the "January 2023 DNV upload" folder on the Gdrive have matching file names (without considering the file extension) with job numbers in the CCTV_Details table.
There are 2554 job numbers in the CCTV_Details table without their corresponding videos on the Gdrive.
There are 2100 videos on the Gdrive without their corresponding condition data.
The inspector did not move back to make sure the tap is visible in the frame when logging tap code. Therefore, we might have to decrease the distance value reported in condition data by 0.1 or 0.2 to get the frame where tap is visible.
SANMN02925_601.mp4 should at list SRI (surface roughness increased) or SRV( reinforcement visible)
Feb 23
create a diagram
add issue with new data slide. The inspector did not move back to make sure the tap is visible in the frame when logging tap code. Therefore, we might have to decrease the distance value reported in condition data by 0.1 or 0.2 to get the frame where tap is visible
WRc vs PACP
- code is identical
- code is different
WRc label replace by PACP
Adding infomration from Joint column to PACP. For an example if B is at Joint, add label as BJ.
Defect prediction (pure feature engineering)
- What install
- age vs when defect happen (age at which defect is noted)
- pipe material
- pipe shape
- soil type
- type flow
Add the evolution of defect standard in Thesis
Feb 24
- SANMN05099_50.csv from the new OCR Processor with Azure matches with the one generated from the old OCR Processor with Azure notebook